MERGE JOIN SEMI
Short Description
Merge semijoin.
Where to use​
Semi Joins are different from normal joins as they return rows from the left hand source at most once. They appear where EXISTS
or IN
clauses are used.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.